[dbo].[MemorialTributeCodeRef]

Property	Value
Created	10:31:27 AM Tuesday, March 02, 2010
Last Modified	11:40:04 AM Monday, February 20, 2012

Property

Value

Created

10:31:27 AM Tuesday, March 02, 2010

Last Modified

11:40:04 AM Monday, February 20, 2012

Name	Data Type	Max Length (Bytes)
MemorialTributeCodeKey	uniqueidentifier	16
Code	nvarchar(50)	100
Description	nvarchar(200)	400

Name

Data Type

Max Length (Bytes)

Allow Nulls

MemorialTributeCodeKey

uniqueidentifier

Code

nvarchar(50)

100

Description

nvarchar(200)

400

	Name	Columns	Unique
	PK_MemorialTributeCodeRef	MemorialTributeCodeKey
	AK_MemorialTributeCodeRef_MemorialTributeCodeDesc	Code

Name

Columns

Unique

PK_MemorialTributeCodeRef

MemorialTributeCodeKey

AK_MemorialTributeCodeRef_MemorialTributeCodeDesc

Code

SQL Script

CREATE TABLE [dbo].[MemorialTributeCodeRef]
(
[MemorialTributeCodeKey] [uniqueidentifier] NOT NULL,
[Code] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[MemorialTributeCodeRef] ADD CONSTRAINT [PK_MemorialTributeCodeRef] PRIMARY KEY CLUSTERED ([MemorialTributeCodeKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MemorialTributeCodeRef] ADD CONSTRAINT [AK_MemorialTributeCodeRef_MemorialTributeCodeDesc] UNIQUE NONCLUSTERED ([Code]) ON [PRIMARY]
GO